How can I get a column details and their data type by using stored procedure in SQL server ?

Question

Anonymous User · Answer

If you want to get Stored Procedure Result Column details and datatype Types use the following Script:
EXEC sp_describe_first_result_set N'YourStoredProcedureName'
If you want to get table Column details and datatype Types or Name use the following Script:
exec sp_columns yourtablename

forum

How can I get a column details and their data type by using stored procedure in SQL server ?

Anonymous User

Can you answer this question?

1 Answers

Liked By